﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using LLFM.CAT.Model;
using LLFM.CAT.Config;
using Common;
using System.Data;
using System.Data.SqlClient;

namespace LLFM.CAT.Service
{
    public class CityService
    {
        public static List<M_City> GetCityListByProvinceId(int provinceId)
        {
            DataTable dt = SqlHelper.ExecuteDataset(DBConfig.BitautoSDT
                , CommandType.StoredProcedure
                , "pro_GetCityListByProvinceId",
                new SqlParameter("@ProvinceId", provinceId)).Tables[0];
            return ModelHelper.FillModelsFromDataTable<M_City>(dt);
        }
    }
}
